if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].sp_KhuVuc_GetAllOrderByName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].sp_KhuVuc_GetAllOrderByName
GO

CREATE PROCEDURE sp_KhuVuc_GetAllOrderByName
AS
	SELECT	ID,Ten,Ghi_chu,Ngay_cap_nhat_cuoi from KhuVuc order by ten